﻿CREATE PROCEDURE [dbo].[proc_Assets_Names_Update]
	(
		@Title nvarchar(50),
		@Sort int,
		@CategoryId int,
		@GId uniqueidentifier,
		@typeid int
	)
AS
	Update Assets_Names Set Title=@Title,Sort=@Sort,CategoryId=@CategoryId,typeid=@typeid Where GId=@GId
	
	update Assets set typeid=@typeid,CategoryId=@CategoryId where nameid=(select id from Assets_Names where GId=@GId)
	RETURN
